﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Jumpton.SFA.Server.Entity;
using Jumpton.Persistent;
using Jumpton.Data;
using System.Data;

namespace Jumpton.SFA.Server.BusinessRule.GIS
{
    public class GISManager
    {
        public DataTable GetVisitLocation(string userID, DateTime visitDate)
        {
            int day = ((int)visitDate.DayOfWeek) == 0 ? 7 : (int)visitDate.DayOfWeek;
            return SqlData.OpenSP("[sp_SelectVisitGIS]", userID, visitDate.ToString("yyyy-MM-dd"), day).Tables[0];
        }
    }
}
